﻿CREATE PROCEDURE Insert_DataTypeTable
	@TableId int OUTPUT,
	@IntField int,
	@IntEnumField int,
	@NVarCharEnumField nvarchar(100),
	@BitField bit,
	@DateTimeField datetime,
	@DecimalField decimal(18   ,6    ),
	@FloatField float,
	@MoneyField money,
	@NTextField ntext,
	@NVarCharField nvarchar(100),
	@RealField real,
	@GuidField uniqueidentifier,
	@ImageField image,
	@VarBinaryField varbinary(50)
AS
INSERT INTO [DataTypeTable] (
	[IntField],
	[IntEnumField],
	[NVarCharEnumField],
	[BitField],
	[DateTimeField],
	[DecimalField],
	[FloatField],
	[MoneyField],
	[NTextField],
	[NVarCharField],
	[RealField],
	[GuidField],
	[ImageField],
	[VarBinaryField]
)
VALUES
(
	@IntField,
	@IntEnumField,
	@NVarCharEnumField,
	@BitField,
	@DateTimeField,
	@DecimalField,
	@FloatField,
	@MoneyField,
	@NTextField,
	@NVarCharField,
	@RealField,
	@GuidField,
	@ImageField,
	@VarBinaryField
)
SET @TableId = @@Identity


